﻿
<!DOCTYPE html>
<html>
<head>
    <title>Manage sheet view presets</title>
    <meta charset="utf-8" />
    <meta name="description" content="Manage sheet view presets in the Spreadsheet Editor" />
    <link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
    <link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
    <script type="text/javascript" src="../callback.js"></script>
    <script type="text/javascript" src="../search/js/page-search.js"></script>
</head>
<body>
    <div class="mainpart">
        <div class="search-field">
            <input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
        </div>
        <h1>Manage sheet view presets</h1>
        <p>ONLYOFFICE <a href="https://www.onlyoffice.com/en/spreadsheet-editor.aspx" target="_blank" onclick="onhyperlinkclick(this)"><b>Spreadsheet Editor</b></a> offers a <b>sheet view</b> manager for view presets that are based on the applied filters. Now you can save the required filtering <!--and sorting -->parameters as a view preset and use it afterwards together with your colleagues as well as create several presets and switch among them effortlessly. If you are collaborating on a spreadsheet, create individual view presets and continue working with the filters <!--and sorting parameters -->you need without being disrupted by other co-editors.</p>
        <h2>Creating a new sheet view preset</h2>
        <p>Since a view preset is designed to save customized filtering <!--and sorting--> parameters, first you need to apply the said parameters to the sheet. To learn more about filtering<!-- and sorting-->, please refer to <span><a href="../UsageInstructions/SortData.htm" onclick="onhyperlinkclick(this)">this page</a></span>.</p>
        <p>There are two ways to create a new sheet view preset. You can either</p>
        <ul>
            <li>go to the <b>View</b> tab and click the <div class = "icon icon-sheetview_icon"></div> <b>Sheet View</b> icon,</li>
            <li>choose the <b>View manager</b> option from the drop-down menu,</li>
            <li>click the <b>New</b> button in the opened <b>Sheet View Manager</b> window,</li>
            <li>specify the name of the sheet view preset,</li>
        </ul>
        <p>or</p>
        <ul>
            <li>click the <div class = "icon icon-new_icon"></div> <b>New</b> button on the <b>View</b> tab located at the top toolbar. The preset will be created under a default name <em>“View1/2/3...”</em>. To change the name, go to the <b>Sheet View Manager</b>, select the required preset, and click <b>Rename</b>.</li>
        </ul>
        <p>Click <b>Go to view</b> to activate the created view preset.</p>
        <h2>Switching among sheet view presets</h2>
        <ol>
            <li>Go to the <b>View</b> tab and click the <div class = "icon icon-sheetview_icon"></div><b>Sheet View</b> icon.</li>
            <li>Choose the <b>View manager</b> option from the drop-down menu.</li>
            <li>Select the sheet view preset you want to activate in the <b>Sheet views</b> field.</li>
            <li>Click <b>Go to view</b> to switch to the selected preset.</li>
        </ol>
        <p>To exit the current sheet view preset, <span class="icon icon-close_icon"></span> <b>Close</b> icon on the <b>View</b> tab located at the top toolbar.</p>
        <h2>Managing sheet view presets</h2>
        <ol>
            <li>Go to the <b>View</b> tab and click the <div class = "icon icon-sheetview_icon"></div> <b>Sheet View</b> icon.</li>
            <li>Choose the <b>View manager</b> option from the drop-down menu.</li>
            <li>Select the sheet view preset you want to edit in the opened <b>Sheet View Manager</b> window.</li>
            <li>
                Choose one of the editing options:
                <ul>
                    <li><b>Rename</b> to rename the selected preset,</li>
                    <li><b>Duplicate</b> to create a copy of the selected preset,</li>
                    <li><b>Delete</b> to delete the selected preset.</li>
                </ul>
            </li>
            <li>Click <b>Go to view</b> to activate the selected preset.</li>
        </ol>
    </div>
</body>
</html>